REFERENCE
-------------------

Döring, Holger and Philip Manow. 2015. Parliaments and governments database (ParlGov): Information on parties, elections and cabinets in modern democracies.

Stable version 2015 — 12 March 2016

www.parlgov.org — dataverse.harvard.edu/dataverse/parlgov


TABLES
-------------------

view_cabinet — Cabinet and opposition parties in parliament with their seat strength at each instance of government formation. (main view)

view_election — Election results for national and European Parliament elections. (main view)

view_party — Party information and merge table for various external data sets on party positions. (main view)

view_variable — documentation of variables in main data tables (party, election, cabinet)

- documentation of all ParlGov database tables in «info_table» and «info_variable»
- text files are utf-8 encoded
- stable version without pre-1945 data


CREDITS
-------------------


## Project leaders

* Holger Döring 2005-today
* Philip Manow 2004-today

## Institutional affiliation

* University of Bremen, Centre for Social Policy Research (ZeS) 2010–today
* European University Institute (EUI) 2009–2010
* University of Heidelberg 2009–2010
* University of Konstanz 2007–2009
* Max Planck Institute for the Study of Societies (MPIfG) 2004–2007

## Major contributors

* Jan Biesenbender (University of Konstanz) 2008–2010
* Jonathan Bright (European University Institute) 2011–2013
* Dominic Heinz (MPIfG and University of Bonn) 2006–2007
* Jens Hoffmeister (underline webdesign Berlin)  2010
* Conor Little (European University Institute) 2011–2014
* Valentin Schröder (University of Bremen) 2010–today
* Mathias Steudtner (Mittweida) 2007–2008
* Hendrik Zorn (MPIfG) 2004

## Open source software

* Python — programming language
* Django — web application framework
* Bootstrap — front–end framework for web development.
* R and RSQLite, SQLite

## Icons and pictures

* Font Awesome
* Famfamfam flag and silk icons
* iStockphoto

## Contributors

We would like to thank the following people for contributing facts, support, ideas, and encouragement.

* Christine Arnold (University of Maastricht) 2012
* Hanna Bäck  (University of Mannheim) 2010–today
* Micha Bächle (University of Konstanz) 2009
* Ryan Bakker (University of Georgia) 2014
* Florian Beyer (University of Konstanz) 2008–2009
* Christian Breunig (MPIfG and University of Seattle) 2006–2008
* Lars Brückner (University of Bremen) 2010
* Mihail Chiru (Central European University) 2012–2013
* Kevin Deegan-Krause (Wayne State University) 2014–today
* Patrick Dumont (University of Luxembourg) 2010–2012
* Sarah Engler (University of Bern) 2015
* Sebastian Eppner (University of Potsdam) 2009–today
* Timm Frerk (University of Bremen) 2011–2013
* Marco Frisone (University of Bologna) 2012
* Fabio Franchino (University of Milan) 2008–2010
* Mark Franklin (European University Institute) 2009–2010
* Doru Frantescu (VoteWatch Europe) 2013
* Simon Franzmann (University of Cologne) 2006–2012
* Johannes Freudenreich (University of Potsdam) 2009–2011
* Steffen Ganghof (MPIfG and University of Potsdam) 2005–2012
* Diego Garzia (University of Siena) 2011
* Aline Grünewald  (University of Bremen) 2011
* Philipp Harfst (University of Greifswald) 2007-2013
* Frank Henze (Brandenburg Technical University of Cottbus) 2005–2011
* Johan Hellström (University of Umeå) 2009–today
* Phillip Hocks (University of Bremen) 2015
* Bjørn Høyland (University of Oslo) 2009
* Sebastian Hübers (MPIfG and University of Tübingen) 2006
* Sebastian Jäckle (University of Freiburg) 2011
* Lea Kaftan (University of Cologne) 2014
* Alexia Katsanidou (GESIS Cologne) 2011
* Ofer Kenig (The Israel Democracy Institute, Jerusalem) 2014
* Svanur Kristjansson (University of Iceland) 2014
* Johannes Kleibl (University of Essex) 2010
* Jürgen Lautwein (MPIfG) 2007
* Pola Lehmann (WZB Berlin Social Science Center) 2014
* Julian Limberg (University of Bremen) 2013–2015
* Volker Lindhauer (University of Bremen) 2011
* Georg Lutz (University of Lausanne) 2012
* Mikko Mattila (University of Helsinki) 2009
* Peter Mair (European University Institute) 2009–2010
* Quinton Mayne (European University Institute) 2009–2010
* Peter Meißner (Universität Konstanz) 2015
* Monika Mühlböck (IHS Vienna) 2009–2010
* Thomas Mustillo (Purdue University) 2014
* Moritz Muth (University of the Arts Bremen) 2013
* Eva Onnudottir (University of Mannheim) 2014
* Zsófia Papp (HAS Centre for Social Sciences, Budapest) 2014
* Sinziana Popa (MPIfG and Duke University) 2007
* Jonathan Polk (University of Gothenburg) 2014
* Sven Regel (WZB Berlin Social Science Center) 2011–today
* Phillip Rehm (WZB Berlin Social Science Center and Duke University) 2007
* Jan Rose (Berlin) 2005–2011
* Armin Schäfer (MPIfG) 2005–2007
* Jan Schwalbach (University of Bremen) 2015
* Mattan Sharkansky (University of Rochester) 2015
* Madeleine Schneider (Swiss Federal Statistical Office) 2012
* Lina Schwarz (University of Bremen) 2014–today
* Julia Sievers (University of Bremen) 2006–today
* Peter Söderlund (Åbo Akademi) 2015
* Patrick Statsch (University of Bremen) 2013
* Jef Smulders (KU Leuven) 2013–2016
* Pawel Szczerbak (Heidelberg University) 2010–2011
* Guido Tiemann (IHS Vienna) 2006–2011
* Alexander Trechsel (European University Institute) 2009–today
* Maria Thürk (University of Bremen) 2013–2015
* Luca Verzichelli (University of Siena) 2007–today
* Nina Wiesehomeier (Swansea University) 2008–today



CHANGES
-------------------


# Development Version

## Data

### New information

 * 2016 elections and cabinets -- see [news](http://www.parlgov.org/documentation/news/?type__short=recent)
*  adding pre-1945 cabinets -- _development version_

### Corrections and updates

* _to be added_


# Version 2015

Stable version released on 12 March 2016

## Data

### New information

 * 2015 elections and cabinets
 * pre-1945 election results -- _development version_

### Corrections and updates

* tables (csv and xlsx) in _stable version_ include only information from 1945 to 2015
* database includes also pre-1945 information from _development version_

* AUT party: removed ApE
* BGR election 2013: recoded NDSV into CSD
* BGR party: corrected several short party names
* CHE party: renamed FraP into FGr-ASF
* CYP party: removed A+D+E
* DNK election 2005: corrected seats GrFa
* EST elections 1992 and 1995: removed electoral alliances Left Alternative and Oigus
* FRA election: recoded election dates to last date of election
* HUN election 1994: added KP
* HUN party: recoded CP into KDNP
* ISL election 1987: added FM and Thod
* ISR cabinet 1996: Netanyahu I split into three cabinets
* ISR election 1996: separate seats for Likud-Gesher-Tzomet alliance
* ISR election 2006: added HY
* ISR party: recoded Gahal into Likud
* ITA party: recoded SI and PSI-07 into P|SDI
* JPN party: recoded PLP into PLFP
* LTU election 1992: added electoral alliance For a United Lithuania
* LVA election 1995, 1998: added electoral alliance KDT/LSDA
* LVA election 1995: added new party LZ, added electoral alliance LSP+L
* LVA election 1998: removed LZS+KDS, alliance of LZP, KDS and Labor Party added
* LVA election 2006: recoded Motherland into SDLP
* LVA president 2007: added Valdis Zatlers
* NLD cabinet 1977: recoded KVP and ARP into CDA
* NOR election 2009: corrected date
* POL election 1991, 1993: recoded WAK and O into ZChN, removed WAK and O
* POL election 1997: UPRz recoded into UPR, removed UPRz, added PC, PCD, PL to AWS
* POL party: recoded PJKM into UPR|KNP
* ROU election 1990: removed electoral alliance AUL
* SVK party: removed SD
* SVN election 1990: SOPS added
* SVN party: DZL and ZEO added

## Webpage

 * relaunch with new [Bootstrap 3](http://getbootstrap.com/) based layout (Dec 2014)

## Database

 * fixed issue in data dump -- 2014 stable version excluded ISR and TUR election and cabinet data
 * Excel spreadsheet export of main tables


# Version 14/12

Stable version 29 December 2014

## Data

### New information

 * country added: TUR, ISR
 * added presidents
 * updated from seats to votes level data: HUN, CHE, EST (completing votes level for all countries)

 * elections added: EP elections 2014, HUN 2014, BEL 2014, SVN 2014, SWE 2014, NZL 2014, LVA 2014, BGR 2014, JPN 2014
 * cabinets added: LVA Straujuma I, CZE Sobotka, DNK Thorning-Schmidt II, ITA Renzi, ROU Ponta III, CYP Anastasiades II, EST Roivas, FIN Katainen II, FRA Valls, HUN Orban III, FIN Stubb, FRA Valls II, BGR Bliznashki, BEL Di Rupo II, SVN Cerar, FIN Stubb II, POL Kopacz, BEL Michel, SWE Loefven, NZL Key III, LVA Straujuma II, BGR Borisov II, ROU Ponta IV, ISR Netanyahu VI, JPN Abe IV
 * added EU Commission 2014

### Corrections and updates

 * removed countries not fully covered: ALB, GDR, LIE, NIR, SCO, WAL; CHL, KOR, MEX, USA, EU
 * PRT vote shares updated to calculated values (CNE source reports share based on total votes)
 * FRA EP elections 1979 to 2009 revised and updated
 * EST electoral alliances revised

 * AUS election 1945: recoded election date
 * AUS party: recoded VdU into FPO
 * AUT party: recoded ALP (1910-14) into CLP
 * AUT party: recoded ALP (1922) into LP
 * AUT party: recoded NCL-NSW into LLP
 * BEL party: recoded FDF+RW into FDF
 * BEL party: recoded PRL/FDF into PRL
 * BGR party: recoded NAPRED into ZNS
 * BGR party: recoded PDS into PBSD
 * CHE party: recoded FDP into FDP-PRD
 * CYP cabinet: Clerides III, IV recoded etc into LP
 * CZE party: recoded LEV21 into CSS
 * CZE party: recoded SNK into SNK-ED
 * CZE party: recoded ULD into US
 * DEU election: added largest party no seat (first loser) with less than 1.0% vote share
 * DEU party: recoded Gruene into B90/Gru
 * DEU party: recoded Linke into Li/PDS
 * ESP party: added CV with election results and alliance membership
 * EST party: recoded EDP into ESE
 * EST party: recoded EME into ERa
 * EST party: removed ESDTP, RKI+SP
 * FIN election 1927 to 1939: added &#39;no seat&#39; party results
 * FIN election 1927-1936: added &#39;electorate&#39;, &#39;total_votes&#39;, &#39;valid_votes&#39;
 * FIN party: added PMP and updated election results
 * FIN party: recoded SKP and VAS into DL/VAS
 * GRC party: unified &#39;party_name_short&#39; to Greek party names
 * HUN election EP 2009: recoded seats Fidesz and KDNP
 * HUN party: recoded MSZMP into MMP
 * IRL election EP: recoded &#39;none&#39; into MEPs winning seats twice
 * ISL election 1963: corrected &#39;electorate&#39; and &#39;votes_total&#39; (swapped)
 * ISL party: Ab - updated information about alliance members and seats distribution
 * ITA cabinet 1970: split PSU into PRI and PSU
 * ITA party: recoded FDP into PCI
 * ITA party: recoded FSN into PD
 * ITA party: recoded Lib/Rep into PRI
 * ITA party: recoded PSI/AD into PSI
 * JPN party: recoded RP into DP
 * JPN party: recoded TPJ into PLF/TPJ
 * JPN party: removed SPJ, PLP
 * LTU election 1992: corrected election date
 * LTU party: recoded L+L+L into LKDP
 * LTU party: recoded SK into TS-LK
 * LTU party: recoded TS-LKD into TS-LK
 * NLD cabinet: recoded Balkenende I-VI (split Balkenende I)
 * NLD party: recoded DMP into NMP
 * NZL cabinet: recoded start date Key II
 * POL party: recoded PPPP into PPG and removed MP
 * POL party: recoded RuPa into ROP
 * POL party: recoded UD into UW-PD
 * ROU party: recoded ARD into PL-D
 * ROU party: recoded FDSN into PSD
 * ROU party: removed ADA, PSD/PC, USL
 * SVK election EP 2009: corrected &#39;electorate&#39;
 * SVK party: split SDL into SDL and SDL-05
 * SVN election 2000: corrected &#39;electorate&#39;
 * SVN party: recoded NDS into SDZ
 * SVN party: recoded SKD into NSI

## Webpage

 * _maintenance_ dev.parlgov.org

## Database

 * added table &#39;politician_president&#39;
 * added view &#39;view_variable&#39; for documentation of main tables
 * table &#39;viewcalc_election_parameter&#39; -- added variable &#39;turnout&#39;
 * removed table &#39;election_ep&#39;


# Version 13/12

## Data

### New information

 * country added: HRV (since 2000)
 * elections added: NLD 2012, LTU 2012, ROU 2012, JPN 2012, ITA 2013, MLT 2013, NOR 2013, DEU 2013, AUT 2013, AUS 2013, LUX 2013,
   CZE 2013
 * cabinets added: NLD Rutte III, ROU Ponta II, JPN Abe III, MLT Muscat, ITA Letta I/II, GRC Samaras II, CZE Rusnok, CYP Anastasiades, NOR Solberg, AUS Abbott, LUX Bettel, AUT Faymann II, DEU Merkel III

 * updated from seats to votes level data: ISL, MLT, LUX, BGR, CAN, ROU, IRL, CZE, ESP, GRC, LTU, SVN, SVK, FRA, NLD and all EP elections

### Corrections and updates

 * compact version of stable release only
 * recoding party families
   * all parties are classified into main categories first
   * additional party families in table &#39;party_family&#39; only
   * imputation of missing party positions by party family
 * Chapel Hill Expert Survey (CHES) party ids updated for 2010 survey
 * Commissioners: updated variable &#39;elected&#39;
 * fixed issue in calculation of &#39;viewcalc_parliament_composition&#39;
 * Changed all party names to include only ascii characters for respective variables
 * BGR cabinet: updated all cabinet sources and descriptions
 * DEU: added CDU/CSU party group to parliament changes and cabinets
 * ITA elections 1994 to 2008:
   * recoded major alliances into Centre Left and Centre Right
   * recoded smaller parties (alliances) only recorded as alliances
   * removed parties only recorded as alliance members (no seats, no votes)
   * no nesting of alliances in alliances for election results (data_json entry now)

 * AUT election: fixed typos in several election descriptions
 * AUT party: recoded K/L into KPO
 * AUT party: recoded WdU into VdU
 * BEL party: recoded CD&amp;V into CVP
 * BGR cabinet 1995: Videnov recoded BSP, BZNS, PKE into SDS
 * BGR election 2009: updated source
 * CAN party: recoded RPC into CA
 * CZE cabinet 1993: Klaus II added KDS
 * CZE cabinet 1998: Tosovsky recoded ODS into US and PM party into &#39;none&#39;
 * EST party: recoded MKE into K-EUR
 * FRA cabinet 1988: Rocard I+II added MRG
 * FRA cabinet 2012: recoded V into PRG
 * FRA election EP 2009: updated turnout data
 * GBR election EP 1979 to 2004: updated turnout data
 * GBR election EP 1999: added turnout data and SF
 * GRC election EP 1981: updated results
 * ISL election 1942, 1959 and 1979: recoded date of election to last election date
 * ISL election 1943 to 1963: added votes
 * ISL election 1943 to 1991: updated source
 * ITA cabinet 1994: Berlusconi I added UdCe
 * ITA party: recoded CI into PdCI
 * ITA party: recoded LAD into R
 * JPN party: removed &#39;votes&#39; and &#39;vote_share&#39; for &#39;others&#39;
 * LTU cabinet 2006: Kirkilas recoded &#39;start_date&#39;
 * LTU party: recoded VP/NDP into LVLS
 * LVA party: recoded DT and LSA into LSDSP
 * MLT party: recoded DA into AD
 * NLD party: recoded RKSP into RKP
 * NOR party: recoded R into RV
 * NZL election 1978: updated &#39;electorate&#39;
 * POL election 1993: recoded S into SRP
 * PRT cabinet 1975: added Pinheiro de Azevedo cabinet
 * SVK party: recoded ESWS into SMK-MKP
 * SVK party: recoded SDKU into SDKU-DS

## Webpage

 * _maintenance and polishing_ dev.parlgov.org
 * added favicons

## Database

 * _none_


# Version 12/10

Stable version 15 October 2012

## Data

### New information
 * elections added: DNK 2011, LVA 2011, POL 2011, ESP 2011, NZL 2011, CHE 2011, SVN 2011, SVK 2012, FRA 2012
 * cabinets added: CYP Christofias IV, JPN Noda, DNK Thorning-Schmidt, LVA Dombrovskis IV, SVK Radicova II, ITA Monti, GRC Papademos, POL Tusk II, NZL Key II, ESP Rajoy, CHE Bundesrat 2011, BEL Di Rupo, SVN Jansa II, ROU Ungureanu, SVK Fico II, NLD Rutte II, CZE Necas II, ROU Ponta, SVK Pahor, FRA Ayrault I+II

 * updated from seats to votes level data: AUT, NZL
 * AUS: elections and cabinets 1901 to 1945
 * CHE: elections and cabinets 1919 to 1943

 * seats data in &#39;view_cabinet&#39; take into account changes in parliament composition (if data available)
 * added application to calculate political composition of the European Union

### Corrections and updates
 * party clean up: removed minor parties without election results or two external data points
 * party positions: fixed error in calculating party positions based on Benoit/Laver (2006)
 * threshold including election results: removed election results for parties with less than 1.0% vote share (no seats)
 * CHE election 1947 to 2007: updated source

 * AUS election 2010: added results CLP
 * AUT cabinet 1964 and 1997: Klaus I and Klima cabinet split into two cabinets -- three month constrain
 * AUT cabinet 2011: Schuessel IV updated &#39;parliament_change&#39; to include BZÖ seats
 * AUT election 1953: coded VdU and ApE as alliance members of WdU
 * AUT party: split VdU/FPO into VdU and FPO
 * BEL cabinet 2008 to 2001: recoded CD&amp;V/N-VA into CD&amp;V for Rompuy, Leterme II, Leterme II
 * BEL cabinet: added Van and Vanden to names of respective PMs
 * BEL cabinet: removed roman number from cabinet names for PMs with single term
 * BEL cabinet: renamed Eyskens into Eyskens G
 * BGR cabinet 1995: Videnov added coalition partners BZNS and PKE
 * CAN election 1979: added SCP and corrected seats NDP
 * CAN election 2008 and 2011: added official election results
 * CAN election: updated source
 * CHE cabinet 2008: added BDP
 * CHE party: merged PSU into PSA
 * CYP cabinet 2008: Christofias I split into two cabinets due to EDEK withdrawal
 * DEU cabinet: &#39;description&#39; added results confidence votes
 * DEU party: added &#39;uh&#39; to cover changes in parliament composition due to resignation of MPs and surplus seats
 * DNK election 1953: April -- corrected G/F seats
 * DNK election 2001: recoded Mp into FrP
 * DNK election EP 1979: corrected seats KF and seats_total
 * DNK election EP 1984: corrected seats Sf and seats_total
 * DNK election EP 1979 to 1989: updated source added parties with more than 1.0% vote share
 * ESP election EP 1987: updated results
 * FIN cabinet 1962: Karjalainen I added SK
 * FIN cabinet 1971: one PM party in Karjalainen III only
 * FIN election 1962: corrected vote share VI
 * FRA election 2002: recoded ER/PRG into Droite and GE into V, added FN
 * FRA election EP 1997: recoded ER/PRG into PRG
 * GBR cabinet: updated source
 * GBR election 2010: added Alliance (1 seat)
 * GBR election EP 2009: removed UCU-NF (party_id 1243) and coded alliance with Uup
 * GBR election EP 2009: UCU-NF added UUP and CNI alliance members
 * GRC election 2007 and 2009: updated source
 * ISL cabinet 1942: added Thordarson
 * ISL election 1942: added results
 * ITA cabinet 1996: split Dini into Dini I and Dini II -- three month constrain
 * ITA cabinet 1999 and 2000: D&#39;Alema I and Amato II split DINI into RI and SDI
 * ITA cabinet: recoded non-partisan PMs from &#39;none&#39; into &#39;PC&#39;
 * ITA election: corrected and updated some results
 * JPN cabinet 1947: added NCoP
 * JPN cabinet 1993: added DRP
 * JPN cabinet 2003: removed NCP
 * LTU cabinet 2010: split Kubilius II into Kubilius II and Kubilius III -- party change
 * LTU election 1996: corrected and updated results
 * LUX election 1948 and 1951: updated partial election results
 * LUX election EP 1979 to 2004: updated results
 * LVA election 2010: corrected vote share
 * NLD election EP 1994: corrected GroenLinks vote share
 * NLD election EP 1994: recoded SGP into SGP/GPV/RP, corrected seats added alliance members
 * NLD election EP 1999: SGP/GPV/RP added alliance members
 * NLD election EP 2009: corrected GroenLinks and ChristenUnie-SGP votes
 * NOR election 1973 to 2009: extended to 1.0% coding threshold
 * NOR election 1973: minor corrections of vote share and updating data source
 * NOR election 1977: minor corrections and additions
 * POL election 1991: removed PPG and MP and added seats to PPPP
 * ROU cabinet: removed Dejeu 1998, Athanasiu 1999, Bejinariu 2004 -- three month constrain
 * ROU cabinet 1996 to 1999: Ciorbea, Vasile, Isarescu cabinet parties recoded USD into PD and PSDR, CDR into PNT-CD and PNL
 * ROU cabinet 2000: split Nastase into Nastase I and Nastase II -- party change
 * ROU cabinet 2009: split Boc II into Boc II and Boc III -- party change
 * ROU election 1992: split CDR seats into alliance members
 * ROU election 2008: corrected ADA alliance members; corrected etnice; updated source
 * SVK election EP 2009: corrected SDKU-DS vote share
 * SVN cabinet 1993: Drnovsek II recoded DS into SDS
 * SVN election 2008: updated source, added votes, turnout data and LIPA, LPR, LZCPV and KDS.
 * SWE election 1998 and 2002: updated source
 * SWE election EP 1995: updated source, corrected &#39;electorate&#39;
 * SWE election EP 2004: updated source

## Webpage
 * party -- added information about the calculation of party positions
 * party -- put information about parties (and their names) in external data sets to bottom of page
 * party -- removed information about party seats from index page of all parties per country
 * election, election index -- using new names for effective number of parties
 * election, election index -- disproportionality and advantage ratio with two digits
 * election index -- party with absolute majority of seats underlined
 * cabinet index -- show only one election date
 * home section -- show &#39;Quick links&#39; first and add &#39;Data section&#39; with examples
 * documentation -- removed key list from list of data sources (kept in experimental version)
 * download section -- added direct links to csv files of party, election and cabinet table

## Database
 * new table -- &#39;parliament_composition&#39;, &#39;viewcalc_parliament_composition&#39;, , &#39;viewcalc_country_year_share&#39;
 * table &#39;cabinet&#39; and &#39;election&#39; -- fixed bug in determining non-existent previous ids
 * table &#39;cabinet&#39; -- added columns &#39;appointment_date&#39;, &#39;resignation_date&#39; (experimental version)
 * table &#39;cabinet_party&#39; -- added column &#39;description&#39; and moved (most) &#39;comment&#39; entries into it
 * table &#39;election&#39; -- added columns &#39;dissolution_date&#39;, &#39;wikipedia&#39; (experimental version)
 * table &#39;election_result&#39; -- added column &#39;description&#39; and moved (most) &#39;comment&#39; entries into it
 * table &#39;party&#39; -- added column &#39;dissolution_date&#39; (experimental version)
 * table &#39;viewcalc_election_parameter&#39; -- renamed &#39;enep&#39; into &#39;enp_votes&#39; and &#39;enlp&#39; into &#39;enp_seats&#39;
 * table &#39;viewcalc_election_parameter&#39; -- removed results for party family &#39;none&#39; from calculation
 * table &#39;viewcalc_party_position&#39; -- renamed &#39;eu_pro_contra&#39; into &#39;eu_anti_pro&#39;
 * table &#39;viewcalc_party_position&#39; -- don&#39;t overwrite missing &#39;left_right&#39; with &#39;state_market&#39;
 * table &#39;view_party&#39; -- renamed &#39;eu_pro_contra&#39; into &#39;eu_anti_pro&#39;
 * table &#39;view_cabinet&#39;, &#39;view_election&#39;, &#39;view_party&#39; -- added &#39;country_name&#39;
 * table &#39;view_cabinet&#39; -- &#39;seats&#39; now based on &#39;viewcalc_parliament_composition&#39; instead of &#39;election_result&#39;


# Version 11/07

Stable version 26 July 2011

## Data

### New information
 * elections 2011 added: CAN, CYP, EST, FIN, IRL, PRT
 * cabinets added: CAN Harper III, CYP Christofias II, EST Ansip IV, FIN Katainen, FRA Fillon III, IRL Kenny, PRT Coelho, SVN Pahor II
 * added NIR -- parties only

 * updated from seats to votes level data: AUT, CYP, POL
 * JPN: added elections and cabinets from 1945 to 1958

### Corrections and updates
 * recoded nationalist, fascist and right-wing populist party families into &#39;right wing&#39; and added former classifications as additional party families to table &#39;party family&#39;
 * removed some entries used to define full party names from table party_change and added the information to json field in party table (eg. DEU: CDU, CSU; SWE: SAP)
 * replaced missing &#39;left_right&#39; party positions with &#39;state_market&#39; values if available (esp. relevant for Benoit/Laver 2006 data)
 * corrected documentation of variable &#39;date&#39; in &#39;election&#39; table
 * CYP: removed elections and cabinets prior to 1976 (Polity IV score)
   * added Kyprianou III, Kyprianou V, Vassiliou II, Klerides II, Klerides IV, Papadopoulos II

 * AUT cabinet 1945: Figl I split into two cabinets
 * AUT cabinet 2002: Schuessel I split into two cabinets -- three month constrain
 * AUT cabinet 2003: Schuessel II split into two cabinets taking into account FPÖ split (FPÖ, BZÖ)
 * AUT election 1949 to 1962: coded KPO as Communist alliance
 * AUT election 1999 and 2002: corrected seats total
 * AUT election 1995: added turnout data, votes and Nein party, changed vote share
 * AUT election 2008: corrected vote share
 * AUT election EP 1996: corrected vote share
 * AUT election EP 1999: corrected valid votes
 * BEL cabinet 1991: recoded Martens IX starting date -- three month constrain
 * BEL cabinet 2007: Verhofstadt II split into two cabinets -- three month constrain
 * BEL cabinet 2010: Leterme III set start of cabinet to date of election (2010-06-13) -- three month constrain
 * BEL party: KPB-PCB split in 1989 coded (KP and PC); reassigned Ray party expert identifier to PC
 * BGR election 1991: added parties
 * BIH party: EU Profiler removed all links to Croatian parties -- ticket:72
 * BIH party: Benoit/Laver removed Croatian HDZ link
 * CHE cabinet 2008: added Bundesrat 2008 -- ticket:60
 * CHE election 1983: added &#39;others&#39; to election, updated seat composition
 * CHE party: recoded LdU-AdI (party_id 1646) into LdU-ADI (party_id 1264)
 * CYP cabinet 2008: recoded ADK into EDEK
 * CYP election 2006: corrected KISOS and updated (votes) results
 * CYP election EP 2004: added votes and EDEK result
 * CYP party: added &#39;EDEK&#39; to party name of Movement for Social Democracy and updated short party name
 * CZE cabinet 2006: recoded start date of Topolanek I
 * CZE cabinet 2009: updated start date of Fisher cabinet to PM appointment
 * CZE election 2002: recoded date of election to last election date
 * DEU cabinet 1960: Adenauer V split into two cabinets taking into account DP split
 * DEU election 1949: added SSW
 * DEU election 1953 to 2005: corrected valid votes -- ticket:67
 * DEU election 1961: recoded GB/BHE into an electoral alliance (GDP) between GB/BHE and DP
 * DEU election 2009: corrected electorate, total votes, valid votes
 * DEU election EP 1979 to 2004: updated from seats to votes level data
 * DEU election: electoral alliance added for CDU/CSU -- election results still coded at the the CDU and CSU level
 * DEU party: updated predecessor/successor entries Linke and added 2005 electoral alliance
 * DNK election 1945 to 1950: updated sources
 * DNK election 1945 to 1994: corrected number of seats
 * DNK election 1947: added HV
 * DNK election 1957: corrected total seats
 * DNK election 1973 to 1977: added SV as alliance member
 * DNK election 1973: added DU as alliance member
 * DNK party: recoded party family Dansk Folkeparti
 * ESP cabinet 1977 and 1979: Gonzalez renamed into Suarez
 * ESP election 1977: corrected and updated results
 * ESP party: recoded CHA (party_id 1675) into CA (party_id 1367)
 * EST cabinet 2009: Ansip II split into two cabinets
 * EST election 1992 and 1995: updated source, added turnout data, corrected and updated results
 * EST party: added V, EPL, Metsa, ERKL, KunRoh, ETRE, OIG, TEE
 * FIN election 1948 to 1983: updated data sources for RKP-SFP and AS
 * FIN election 1958 and 1962: removed SKL
 * FIN election 1966: added SKDL/TPSL alliance
 * FIN election 1987: corrected SKDL vote share
 * FIN election 1991 and 1995: recoded SKYP results into SEP
 * FIN election 1995: added VSL
 * FIN election 2003: corrected election date
 * FIN election EP 1999: corrected number of seats
 * FIN party: minor updates on party names and predecessor/successor parties
 * FIN party: SKP-97 party names changed into SKP-Y
 * FRA election 2007: corrected vote share and seats, added votes
 * FRA election EP 2009: corrected number of seats Gauche
 * FRA party: added UEM
 * FRA party: recoded UMP Benoit/Laver ID
 * FRA party: removed The Right (party_id 157) duplicate of Other Right (party_id 285)
 * GBR election 1974 to 1987: calculated &#39;vote_share&#39; for some parties from Northern Ireland -- ticket:66
 * GBR election 1983 and 1987: recoded LD as Alliance
 * GBR election EP: added notes about vote share in regions
 * GBR election EP 1999: corrected vote share and number of valid votes
 * GBR party: updated EES IDs for SNP, Plaid, UKIP, PWCL
 * GDR cabinet 1990: Maizere coded changes in party composition and defectors
 * GDR election 1990: coded electoral alliances and its members, corrected number of votes
 * GDR party: updated all entries; coded party changes (including DEU parties)
 * GRC party: added names for KODISO
 * GRC party: recoded and merged EK into EDIK
 * ISL cabinet 1944 and 1946: Thors II, Thors III recoded Ab into So
 * ISL cabinet 1979: Groendal changed into caretaker cabinet
 * ISL election 1946 to 1953: replaced Ab by So
 * ISL election 1967: added OS and updated source
 * ISL party: corrected &#39;þ&#39; transcription into &#39;th&#39; and removed remaining capitalisation of party names
 * ISL party: recoded Thjo (party_id 1637) into Pjo (party_id 205)
 * ITA election 1946 and 1948: recoded PLI results into UDN and BN (alliances), added alliance members
 * ITA election 1963 and 1968: recoded PNM results into PDIUM (new party)
 * ITA party: updated party names and predecessor/successor entries for Socialist parties (PSI, PSDI, PSU)
 * JPN cabinet 1980: Ito removed -- three month constrain
 * JPN cabinet 1993: added NP
 * JPN cabinet 1994: removed LP
 * JPN cabinet 1998: split Obuchi into three cabinets
 * JPN cabinet 2009: renamed Hatoyama into Hatoyama Y
 * JPN election 1958: added votes
 * JPN election 1960 to 1967: added number of votes
 * JPN election 1969 and 1979: corrected number of votes
 * JPN election 2005: corrected number of seats (all parties except LDP and DPJ)
 * JPN election 2009: updated source and added NPD
 * JPN party, election, cabinet: recoded DSP (party_id 1053) into SDP (party_id 940) for elections and cabinets after 1994
 * JPN party: recoded NK into K(CGP)
 * JPN party: unified short names to english version -- ticket:63
 * LTU cabinet 2008: Kubilius II added TPP
 * LTU election 1992: added votes and parties
 * LTU party: added VPJST and LLL
 * LVA election 2010: added seats total
 * NLD cabinet 1977: Den Uyl II; set start of cabinet to date of election (1977-05-25) -- three month constrain
 * NLD election 1977: CDA as electoral alliance (ARP, CHU, KVP)
 * NLD election EP 1999: added electoral alliance SGP/GPV/RPF
 * NOR cabinet 1940: removed Nygaardsvold II
 * NOR cabinet 1945: Gerhardsen I coded as caretaker and parties added
 * NOR election 1961 to 1969: recoded SV into SF
 * NOR election 1973: added SV alliance members
 * NOR party: updated RV names
 * NZL election 1999: changed number of seats NZFP
 * POL cabinet 1991: Olszewski recoded WAK into ZChN (alliance member) and removed PCD
 * POL cabinet 1992 and 1993: Suchocka I and II added PSL, PCD and recoded WAK into ZChN (alliance member)
 * POL party: removed L; recoded PD into UW-PD
 * PRT election 1979: corrected seats of AD alliance members, added Ref and updated source
 * PRT election EP 1994: corrected vote share
 * PRT party: added PAN; recoded party family PSD; removed Benoit/Laver ID from PDC
 * SVN party: removed SA and LU
 * SWE election 1985: updated source, corrected turnout data, coded alliance member

## Webpage
 * party -- show information about electoral alliances and alliance members in election results (superscript symbol)
 * party -- show party foundation date
 * party -- show only year of party change if date is coded as 1 July (default for unknown day/month)
 * election, cabinet -- show name of party for elections and cabinets based on information in table &#39;party_name_change&#39; (if available)
 * election -- moved information about &#39;Changes of party composition in parliament&#39; into experimental version
 * election -- show only results for more than 0.5% vote share
 * cabinet -- don&#39;t show termination date (experimental version observation only)
 * external -- corrected publication year references for Castles/Mair, Ray and EU Profiler
 * data sources -- cleaned up names of some of the entries

## Database
 * new table -- &#39;cabinet_support&#39; to include parties that support (minority) cabinets (experimental version)
 * new table -- &#39;party_family&#39; to include additional party families for a party
 * tables &#39;party&#39;, &#39;party_change&#39;, &#39;party_name_change&#39; -- added column &#39;data_source&#39;
 * table &#39;party&#39; -- added column &#39;description&#39;
 * table &#39;party&#39; -- added column &#39;foundation_date&#39; (experimental version)
 * table &#39;party_change&#39; -- added variable &#39;type_id&#39; (experimental version)
 * &#39;view_cabinet&#39; -- fixed issue in view definition to include all cabinets -- ticket:65
 * &#39;view_election&#39; -- added variable &#39;previous_cabinet_id&#39;


# Version 10/11

Stable version 16 November 2010

## Summary
 * complete database refactoring -- recoding of table/variable names and all id variables -- see below
 * new web design -- Jens Hoffmeister (underline webdesign Berlin) 2010
 * new data: European Election Study (2009) party ids added; Belgium, United Kingdom, Portugal, Latvia updated from seats to votes level data; Swiss cabinets since 1945 added
 * recent elections and cabinets until October 2010 and data corrections -- see below


## Data

### New information
 * elections 2010 added: HUN, GBR, CZE, NLD, SVK, BEL, SWE, AUS, LVA
 * cabinets 2010 added: NLD Balkenende V, ROU Bejinariu, HUN Orban II, GBR Cameron, JPN Kan, FIN Kiviniemi, AUS Gillard, SVK Radicova, CZE Necas, SWE Reinfeldt, AUS Gillard II, LVA Dombrovskis III,

 * updated from seats to votes level data: BEL, GBR, PRT, LVA

 * European Election Study (2009) party ids added
 * CHE all cabinets since 1945 added
 * POL parliament_change -- specification of party composition changes in 2007 parliament

### Corrections
 * BEL cabinet -- recoded party ids for CVP and SP to CD&amp;V/N-VA and SPA/Spirit for all cabinets after 2003 election
 * BEL cabinet -- removed orphaned observations from &#39;cab_party&#39; (old_cabID 19600, 19731, 19732, 19760)
 * BEL cabinet -- renamed Eyskens 1981 into &#39;Eyskens M&#39;
 * BGR cabinet -- Stanishev cabinet coding of BSP as KzB
 * BIH party -- added parties (old_partyID: 11, 15, 21, 22, 26, 30) to match all CMP parties
 * CAN cabinet -- Diefenbaker  II and III added
 * CAN cabinet -- St-Laurent split into I, II, II
 * CAN cabinet -- King III dates corrected
 * CZE cabinet -- Tosovsky coded as &#39;caretaker&#39;
 * CZE election -- recoding &#39;election_date&#39; to last date of election and adding &#39;opening_date&#39; to &#39;datajson&#39;
 * CZE party -- recoded and removed HSD/SMS duplicate (&#39;old_partyID&#39; 52)
 * ESP election ep -- 2004 and 2009 EP election results updated with official sources
 * ESP party -- recoded I (&#39;old_partyID&#39; 71) into IU/PCE (&#39;old_partyID&#39; 57)
 * EST parties -- RKI (1992); RKI/ERSPI, ERSP, I (1995) and affected elections/cabinets -- revising
 * FIN cabinet -- Aura II corrected &#39;start_date&#39; and &#39;end_date&#39;
 * FIN cabinet -- Barre I, Barre II added observations for non-partisan prime ministers (&#39;pm&#39;) to &#39;cabinet_party&#39;
 * FIN cabinet -- Fagerholm II, added L (Liberals)
 * FIN cabinet -- Fagerholm III and Virolainen added Liberals
 * FIN cabinet -- Kekkonen II, added RKP
 * FIN cabinet -- Lipponen I, added VAS
 * FIN cabinet -- Lipponen II, split into II and III following resignation of VIHR
 * FIN cabinet -- Paasikivi, Fieandt, Kuuskoski, Lehto, Aura I, Aura II, Liinamaa added observations for non-partisan prime ministers (&#39;pm&#39;) to &#39;cabinet_party&#39;
 * FIN cabinet -- Sukselainen, Karjalainen, Sorsa II, Sorsa III, Holkeri, Aho recoded as several cabinets due to change in party composition
 * FRA cabinet -- Fillon I,II corrected cabinet name
 * FRA cabinet -- Barre II &#39;starting_date&#39; recoded
 * GBR cabinet -- Eden government split into Eden I and Eden II
 * GBR election -- 1945 corrections
 * GER cabinet -- Adenauer II split into several cabinets and coding of party changes
 * GRC cabinet -- renamed Karamanlis cabinets to avoid duplicated cabinet names
 * HUN cabinet -- Bajnai corrected cabinet name
 * HUN cabinet -- Gyurcsan III removed SzDSz
 * ITA cabinet -- Prodi I and  Amato II added observations for non-partisan prime ministers (&#39;pm&#39;) to &#39;cabinet_party&#39;
 * ITA cabinet -- Moro I government split into I, II, III and recoded later Moro governments into IV and V
 * ITA cabinet -- Spadolini and Craxi government split into I and II
 * ITA party -- PdL duplicate recoded and removed (&#39;old_partyID&#39; 151)
 * ITA party/alliance  -- CCD/CDU unified; recoded old_partyID 140 into 53
 * JPN cabinet -- Hatoyama I added DSP and KS
 * JPN cabinet -- Koizumo II &#39;start_date&#39; recoded to 2003-11-19; previous coding was linked to 2000 election results
 * JPN cabinet -- Ohira I corrected &#39;start_date&#39;
 * LTU cabinet -- renamed Vagnorius cabinets by adding I and II
 * LTU party -- LSDP split into two parties and recoded pre 2001 election results of LSDP to new party ID
 * LVA cabinet -- 1998 legislative term correction of party composition for cabinets
 * LVA cabinet -- Dombrovskis 2009 added
 * LVA cabinet -- Skele I and Skele II added observations for non-partisan prime ministers (&#39;pm&#39;) to &#39;cabinet_party&#39;
 * LVA election -- revision of election results (esp. 2002) during update to vote level data
 * NLD cabinet -- coding of &#39;defector&#39; parties
 * MLT cabinet -- renamed cabinets to avoid duplicated cabinet names
 * NLD cabinet -- Den Uyl government split into Den Uyl I and Den Uyl II (caretaker)
 * NZL cabinet -- Howard I split into two cabinets taking 1951 election into account
 * POL cabinet -- Kaczynski I, II, III, IV recoded into one cabinet -- following more specified cabinet coding rules
 * POL cabinet -- Marcinkiewicz II corrected &#39;startingDate&#39; from 2005 to 2006
 * POL cabinet -- Pawlak I -- added party
 * POL cabinet -- Suchocka II coded as &#39;caretaker&#39;
 * POL election -- LiD dissolution in April 2008 coded
 * POL election -- 1992 PO recoded into POC
 * POL party -- recoding of some party families
 * ROU cabinet -- Athanasiu, Bejinariu coded as &#39;caretaker&#39;
 * SVN cabinet -- Jansa &#39;startingDate&#39; recoded to 2004-12-03; previous coding was linked to 2000 election results
 * SVN cabinet -- Peterle parties recoded
 * SVN cabinet -- Drnovsek II removed ZS
 * SVN election -- 1990 election added
 * SVN election -- added two seats to each election one for Italian and the other for Hungarian national community seat
 * SVN party -- SLS/SKD recoded into SLS

 * corrected differences between coded and calculated (votes/votes_valid) vote shares (except PRT) -- ticket:56

## Webpage

 * new web design

 * further information about cabinet below list of parties in cabinet
 * list &#39;comment&#39; in documentation of table variables
 * show 0 seats on election result pages
 * government type (minority, minimum winning, oversized) on cabinet pages and cabinet index -- ticket:36
 * legend for tables on index pages of elections and cabinets
 * Famfamfam silk icons for links to downloads
 * information about recalculated seat shares in cabinet page
 * smaller font size for election date on list of cabinets

## Database

 * complete database refactoring
   * renaming of tables and variables
   * unique primary keys in all tables (variable &#39;id&#39;)
     - old id variables are kept in core tables with prefix &#39;old_&#39; (eg. &#39;old_partyID&#39; in party table)
   * foreign key enforcement (in Django)
   * &#39;data_json&#39; variable for additional information in some tables (experimental version)
   * coding of all &#39;id&#39; variables in &#39;info_id&#39; -- except variables with an own table (e.g. country, party, election)
